# PyMSQL创建数据库连接
from pymysql import Connection

conn = None
try:
    # 创建数据库连接
    conn = Connection(
        host='localhost',  # 主机地址
        port=3306,  # 端口
        user='root',  # 用户名
        password='root',  # 密码
        database='learn_pymysql',  # 数据库
        autocommit=True  # 配置自动提交
    )
    # 获取游标
    cursor = conn.cursor()

    sql = "delete from regions where `region_id` = 4"

    # 使用游标对象执行sql
    cursor.execute(sql)

except Exception as e:
    print("发生异常：", e)
finally:
    if conn:
        # 关闭连接
        conn.close()
